import matplotlib.pyplot as plt
import pandas as pd
df = pd.read_excel('学生各学期成绩表.xlsx')
fig,axes = plt.subplots(2,2,figsize=(12,8))
ax1 = axes[0,0]
ax2 = axes[0,1]
ax3 = axes[0,0]
ax4 = axes[1,1]
x = df['序号']
ax1.plot(x,df['语文'])
ax2.plot(x,df['数学'])
ax3.plot(x,df['英语'])
ax4.plot(x,df['综合'])
plt.show()